EMPTY

The EMPTY field specifier (case sensitive) allows you to find documents in which a specified field doesn't exist or contains no value.

NOTE: You can optimize the field specifier speed by restricting the field to the NumericType property type.

Format

FieldText=EMPTY{}:yourFields
yourFields One or more fields. A document returns only if it does not contain any of these fields or if these fields are empty. Separate multiple fields with colons (:). There must be no space before or after a colon.

Example

FieldText=EMPTY{}:ID

A document returns if it does not contain an ID field or if the ID field is empty.

FieldText=EMPTY{}:ID:Name

A document returns if it does not contain an ID or Name field, or if the ID and Name field are empty.